package com.sacfa.commons.sql;

public class MunicipioSQL {
	public static final String SELECT_ONE;
	public static final String SELECT_FOR_ESTADO;
    public static final String SELECT_ALL;
    
    static {
        StringBuilder qryBuilder = new StringBuilder();

        qryBuilder.append("SELECT * FROM Municipio WHERE idMunicipio = ?");
        SELECT_ONE = qryBuilder.toString();

        qryBuilder = new StringBuilder();
        qryBuilder.append("SELECT * FROM Municipio WHERE Estado = ?  ORDER BY Descripcion");
        SELECT_FOR_ESTADO = qryBuilder.toString();
        
        qryBuilder = new StringBuilder();
        qryBuilder.append("SELECT * FROM Municipio");
        SELECT_ALL = qryBuilder.toString();
    }
}
